Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Determine the requirements of developing queries
   • Recognise various query-related terminologies
   • Identify the type of data source for a chosen query language
   • Identify and use the necessary tools, and environment, in building queries
2. Write queries to retrieve and sort values
   • Use an expression to retrieve values from a single unit
   • Use an expression to combine values from more than one unit
   • Use an expression to sort values into a certain order
3. Write queries to selectively retrieve values
   • Use an expression to filter a sequence, based on a predicate or a condition
   • Use an expression to filter the subset of a sequence, based on a predicate or a condition
   • Use an expression to extract a specific value by position
4. Perform a calculation in queries
   • Use an expression to perform a calculation on numeric values
   • Use an expression to perform an operation on text values
   • Use an expression to perform an operation on date and time values

Performance Evidence

Evidence of the ability to:

select and use tools in developing, storing, and executing queries to extract the appropriate data required for ad hoc reports, or to support developers

incorporate calculations using control statements, operators and functions.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

---

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

outline the information gathering methods

outline the data analysis techniques

define data mining

outline the characteristics of the data source

explain the features of the information system

explain typical systems and procedures.

---